TillTender

Entity Definition

Logical Name : TillTender
Physical Name : LE_TND_TL

A current, running total of sales, returns, tax, tender and other monetary values and counts accumulated from individual retail and tender control transactions. This running set of totals is cleared to zero upon completion of a till settlement transaction process.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TillID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
OpenBalanceAmount The opening tender balance in the TILL before closing the till settlement period. MO_OPN_BLNC_AMT Money decimal(16,5)
OpenMediaUnitQuantity The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before closing a till settlement period. QU_OPN_MD QuantityInteger integer
CloseBalanceAmount The closing system maintained tender balance in the TILL before formalizing the closing of a till settlement period. MO_CL_BLNC_AMT Money decimal(16,5)
CloseMediaUnitQuantity The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before the formal closing of a till settlement period. QU_CL_MD_UN QuantityInteger integer
CountedBalanceAmount The counted tender balance in the TILL before the fomal closing of a till settlement period. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. MO_CNT_BLNC_AMT Money decimal(16,5)
CountedMediaUnitQuantity The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before the formal closing of a till settlement period. QU_CNT_MD_UN QuantityInteger integer
OverUnderBalanceAmount The variance between closing balance amount and counted balance amount before the formal closing of a till settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) MO_OVR_UND_BLNC_AMT Money decimal(16,5)
OverUnderMediaUnitQuantity The variance between closing media unit quantity and counted media unit quantity before the closing of a till settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) QU_OVR_UND_MD_UN QuantityInteger integer
LoanFromSafeAmount The running total amount of tender loaded to this TILL from a SAFE during a till settlement period before it is formally closed. MO_LON_FR_SF_AMT Money decimal(16,5)
LoanFromSafeMediaUnitQuantity The running media unit quantityt of tender loaded to this TILL from a SAFE during a till settlement period before it is formally closed. QU_LON_FR_SF_MD_UN QuantityInteger integer
PickupToSafeAmount The running total amount of tender picked up from this TILL and moved to a SAFE during a till settlement period before that period is formally closed. MO_PKP_TO_SF_AMT Money decimal(16,5)
PickupToSafeMediaUnitQuantity The running total of media unit quantity of tender picked up from this TILL and moved to a SAFE during a till settlement period before that period is formally closed. QU_PKUP_TO_SF_MD_UN QuantityInteger integer
TipOutAmount The running sum of tip out transaction amounts removed from a till during the till settlement period before that period is formally closed. TP_OT_AMT Money decimal(16,5)
TipOutMediaUnitQuantity The running sum of tip out media unit quantities removed from a till during a till settlement period before that period is formally closed QU_TP_OT_MD_UN QuantityInteger integer
DisbursementAmount The running sum of tender disbursement amounts made from a TILL during a till settlement period before that period is formally closed. This is generally treated as a petty cash payment by retailers and is used to pay service vendors, charities, etc. from a till. MO_DSB_AMT Money decimal(16,5)
DisbursementMediaUnitQuantity The running total media unit quantity paid out of a till as a cash disbursement for a till settlement period before that period is formally closed. QU_DSB_MD_UN QuantityInteger integer
RetailTransactionSettlementAmount The running sum of tender settlement values for retail transactions processed during a till settlement period before that period is formally closed. Retail transaction settlement represent the receipt or paying out of tender as part of balancing a retail transaction (aka settling the transaction). A negative balance means that a balance is paid out to a customer (as in a refund). A positive balance reflects the normal case where tender (cash, db/cr card, check, coupon, gift certificate,EBT, etc.) is paid in to settle a purchase. MO_RTL_TRN_STLM_AMT Money decimal(16,5)
RetailTransactionSettlementMediaUnitQuantity The running sum of retail transaction media unit quantities collected as part of settling retail transactions during a till settlement period before that period is formally closed. QU_RTL_TRN_STLM_MD_UN_QTY QuantityInteger integer
FundsReceiptAmount The running sum of NON-RETAIL sale and non-loan related receipt of tender into a till over a till settlement period before the formal closing of that period. MO_FND_RCT_AMT Money decimal(16,5)
FundsReceiptMediaUnitQuantity The running sum of NON-RETAIL sale and non-loan related receipt of tender media unit quantity into a till over a till settlement period before that period is formally closed. QU_FND_RCPT_MD_UN QuantityInteger integer
TenderExchangeAmount Running sum of tender exchanged with other tills during the till settlement period before that period is formally closed. A negative value indicates a net outflow of tender amount exhanges. A positive value indiates a net inflow of tender amount exchanges. A zero value indicates an even exchange of tender amounts. MO_TND_EXC_AMT Money decimal(16,5)
TenderExchangeMediaUnitQuantity Running sum of tender media unit quantities exchanged with other tills during the till settlement period before that period is closed. A negative value indicates a net outflow of tender media unit quantity exhanges. A positive value indiates a net inflow of tender media unit quantity exchanges. A zero value indicates an even exchange of tender media unit quantity. QU_TND_EXC_MD_UN QuantityInteger integer
AdjustmentAmount The running sum of tender adjustment amount transactions for a till settlement period before that period is formally closed. ADJT_AMT Money decimal(16,5)
AdjustmentMediaUnitQuantity The running sum of tender adjustment media unit quantity transactions for a till settlement period before formally closing that period. ADJT_MD_UN QuantityInteger integer

Relationships

Parent Entity Verb Phrase Child Entity
Tender is tracked by TillTender
Till contains TillTender
TillTender is composed of TillTenderCashDenominationCount

Logical Views containing TillTender

Logical View
Logical 02400 - Control Transaction Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03110 - Reporting - Store Operations - Tender Settlement
Logical 03160 - Reporting - Store Operations - Till View